INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HUMMEL-Q11',
		'Hummel - CEI - 138kV Q11 (AoV)',
		'Hummel - CEI - 138kV Q11 (AoV)',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'connectionHostName=10.98.67.80; connectionUserName=FTPUSER; connectionPassword=&AY4k9H&; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'ELDEN-TR71',
		'Elden - CEI - 13.8kV TR71 (AoV)',
		'Elden - CEI - 13.8kV TR71 (AoV)',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'connectionHostName=10.98.67.116; connectionUserName=FTPUSER; connectionPassword=&AY4k9H&; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PV-Q12',
		'Pleasant Valley - CEI - 138kV Q12',
		'Pleasant Valley - CEI - 138kV Q12',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'ftpType=0; connectionHostName=10.78.134.5; connectionUserName=FTPUSER; connectionPassword=&AY4k9H&; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'PV-Q13',
		'Pleasant Valley - CEI - 138kV Q13',
		'Pleasant Valley - CEI - 138kV Q13',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'ftpType=0; connectionHostName=10.78.134.6; connectionUserName=FTPUSER; connectionPassword=&AY4k9H&; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HARDING-Q12',
		'Harding - CEI - 183kV Q12',
		'Harding - CEI - 183kV Q12',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'ftpType=0; connectionHostName=10.78.128.134; connectionUserName=FTPUSER; connectionPassword=&AY4k9H&; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'HARDING-Q13',
		'Harding - CEI - 183kV Q13',
		'Harding - CEI - 183kV Q13',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'ftpType=0; connectionHostName=10.78.128.135; connectionUserName=FTPUSER; connectionPassword=&AY4k9H&; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
INSERT INTO Device
	(NodeID, Acronym, Name, OriginalSource, IsConcentrator, CompanyID, AccessID, VendorDeviceID, ProtocolID, ConnectionString, FramesPerSecond, TimeAdjustmentTicks, DataLossInterval, AllowedParsingExceptions, ParsingExceptionWindow, DelayedConnectionInterval, AllowUseOfCachedConfiguration, AutoStartDataParsingSequence, SkipDisableRealTimeData, MeasurementReportingInterval, ConnectOnDemand, LoadOrder, Enabled)
	VALUES
		((SELECT ID FROM Node WHERE Name LIKE 'Default'),
		'CAET-SEL735-W1',
		'CAET - SEL735 - Tesco Rack W1',
		'CAET - SEL735 - Tesco Rack W1',
		0,
		(SELECT ID FROM Company WHERE Name LIKE 'First Energy'),
		0,
		1,
		(SELECT ID FROM Protocol WHERE Acronym LIKE 'Downloader'),
		'ftpType=0; connectionHostName=10.89.3.2; connectionUserName=FTPUSER; connectionPassword=; connectionProfileID=1; schedule=0 0 * * *; useDialUp=false; dialUpEntryName=; dialUpNumber=; dialUpUserName=; dialUpPassword=; dialUpRetries=3; dialUpTimeout=90; connectionTimeout=30000; logConnectionMessages=false',
		1,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		0,
		5000,
		0,
		0,
		1)
GO
